package com.itheima.dao;

import com.itheima.pojo.Item;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

public interface ItemMapper {
    @Select("SELECT * FROM tb_item WHERE tb_item.id=#{id};")
    @Results({
            @Result(column = "id",property = "id" ,id = true),
            @Result(column = "item_name",property = "itemName" ),
            @Result(column = "item_price",property = "itemPrice" ),
            @Result(column = "item_detail",property = "itemDetail"),
    })
    Item find02(int id);//根据订单id 查询商品信息
}
